home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-09
/
inv18.zip
/
INV.DOC
< prev
next >
Wrap
Text File
|
1991-05-22
|
30KB
|
758 lines
INV V1.8 DOCUMENTATION, EDITION #1 Page 1
COPYRIGHT 1989-1991 BY DOUGLAS K. BELL, LOMPOC, CALIFORNIA.
HARD DISK INSTALLATION
Follow instructions on disk label. Type SETUP at DOS prompt.
The inventory system will be set up in the directory: \INV
All data files will have the extension .1 and can be backed up to
floppy disk with the command COPY C:\INV\*.1 A:\
and restored with the command COPY A:\*.1 C:\INV
GENERAL
This program stores and keeps track of inventory details, and
automatically prints-out requisitions for items when supplies get
low, or are less than a given number of days supply.
Whenever inventory items are used or re-stocked, the details of
these transactions must be entered into the computer, using the
program. Usage or re-stock "tickets" can be printed out, showing
the details of the transactions. Miscellaneous purchases can also
be tracked.
The following reports can be printed out or displayed:
- Automatic or manual item requisitioning.
- Inventory status of all items, listed in object/item name order.
- Usage or restocking transactions showing transaction details,
costs, and cost totals for any time period, item, object, or
category of item or object.
GENERAL SETUP OPERATIONS
1. Use step <1> "Add/Edit items" to type in the current list of
inventory items. You will need to know, for each item:
- Item name
Use this format: DESCRIPTION, ID or PART NO., etc.
Or, use as much of it as you can.
- Item OBJECT or PURPOSE. Eg: vehicle, machine, project,
acct., dept., etc.
- Physical location,
- Current quantity,
- Quantity limit (below which automatic requisitioning takes
place),
- Purchase quantity (how many to automatically requisition),
- Days Limit (Automatic requisitioning take place if less than
this number of days supply is left.)
- Usual cost per unit, usual vendor (and address), usual
vendor's phone or FAX number.
To print out a form for filling out this information,
type INV-FORM at the DOS command prompt.
INV V1.8 DOCUMENTATION, EDITION #1 Page 2
2. To automatically print-out requisitions (only when required)
whenever the PC is turned on, add a line containing "\INV\INV
REPORT" to the end of the PC's AUTOEXEC.BAT file in the root
directory.
INV V1.8 DOCUMENTATION, EDITION #1 Page 3
GENERAL OPERATION STEPS
1. Whenever a new type of item is added to inventory, an item is
discontinued, or the details of any item need to be changed, run
the program, and execute step <1> "Add/Edit items."
2. Whenever an item is "used" from inventory, run the program and
execute step <2> "Enter USAGE transaction."
3. Whenever supplies of an item get low, or there is less than the
set days supply, FAX-ready requisitions will be printed out
automatically (if the AUTOEXEC.BAT file was set. See GENERAL
SETUP STEPS).
To generate a requisition manually, run the program, and
execute step <3> Print-out PURCHASE REQUISITIONS.
The printed requisitions have internal blanks to be filled out, to
help track re-stocking. When the requisitioned items have been
received, follow step 4.
4. Whenever inventory is re-stocked with an item, run the program
and execute step <4> "Enter RE-STOCKING transactions."
5. To print-out or display a report of USAGE TRANSACTIONS (what,
when, where, and cost) for a single item, a category of items, or
all items, for any period of time, execute step <5> "REPORT
INVENTORY USAGE".
6. To print-out or display a report of RE-STOCKING transactions
(what, what for, when, and cost), for a single item, a category of
items, or all items, for any period of time, execute step <6>
"REPORT INVENTORY RE-STOCK".
7. To print-out or display a report of all items in inventory,
execute step <7> "REPORT INVENTORY".
8. Usage and re-stocking transaction information that has been
entered, can later be searched or changed, using step <8> "EDIT
USAGE TRANSACTION FILE" and step <9> "EDIT RE-STOCKING TRANSACTION
FILE."
If technical assistance is required, or you have a suggestion for
the next version, call 509-633-0120.
INV V1.8 DOCUMENTATION, EDITION #1 Page 4
MISC
In this documentation and on program screens, keyboard buttons are
referred to between <>. For example, the enter key is referred to
as <Enter>.
Frequently, a single line command menu appears on the bottom line.
The key shown between <> will cause the action described to the
right of the <>.
<ESC>
To get out of any program display, back to the MAIN MENU,
press <Esc>. Some data entry fields will not accept <Esc>.
If <Esc> does nothing, press <Enter> to leave the current data
field, and try <Esc> again.
INV V1.8 DOCUMENTATION, EDITION #1 Page 5
STEP <1> "ADD/EDIT ITEMS"
Use step <1> "Add/Edit items" to load in the current status of
inventory.
Whenever a new type of item is added to inventory, an item is
discontinued, or the details of any item need to be changed, run
the program, and execute step <1> "Add/Edit items."
After pressing <1>, the "* * * EDITING ITEMS * * *" screen is
displayed. Each display shows a record of a single inventory
item.
The following data fields are displayed:
ITEM - The name, description, ID, or part no. of the item.
OBJECT or PURPOSE - What the item is for. For instance: vehicle
id, or project code, product code.
IF THE \MAINTAIN PROGRAM IS INSTALLED.
If the \MAINTAIN program has been installed, "OBJECT or
PURPOSE" can also refer to any OBJECT (vehicle, machine,
etc.) entered using the MAINTAIN program. Just enter all
or any part of the object name. This way, full object
descriptions will only have to be entered ONCE using the
\MAINTAIN program.
However, if the object is not from the \MAINTAIN system,
enter its full description.
The bottom line will request the following choices:
<Space>SCAN MAINTAIN FILE FOR MATCH.
If any part of a \MAINTAIN object was entered, use
this command, and the program will automatically enter
the full object name from the \MAINTAIN OBJECTS file.
Each matching object name will be displayed at the
bottom line, along with commands to either accept the
name or keep scanning for another.
<Enter>LEAVE AS IS.
Choose this if the object is not in the \MAINTAIN
OBJECTS file.
1. Type in any part of the MAINTAIN OBJECT name. The
bottom line
Items are stored in object, item name order. Example:
OBJECT ITEM
CARS AIR FILTERS
CARS GAS FILTERS
CARS OIL
INV V1.8 DOCUMENTATION, EDITION #1 Page 6
OFF. SPLY PENCILS
OFF. SPLY PENS
TRUCKS AIR FILTER
TRUCKS GAS FILTER
TRUCKS OIL
UNITS - Eg: EA, lbs., gals, etc.
PHYSICAL LOCATION - Eg: BLDG #1, SHELF 3
QUANTITY - Currently on hand.
QUANTITY LIMIT - The Program requisitions automatically when
QUANTITY drops below this limit.
PURCHASE QUANTITY - How many to buy. Appears on REQUISITION
print-out.
DAYS LIMIT - The Program requisitions PURCHASE QUANTITY more
automatically when it forecasts that QUANTITY will drop to 0
within DAYS LIMIT. Forecasting is based on USAGE TRANSACTIONS.
For example, if PURCHASE QUANTITY is 50, DAYS LIMIT is 7, the
average usage is 2 per day, and QUANTITY has dropped below 14,
then the program will automatically requisition 50 more.
USAGE RATE - Calculated by the program, based on the latest USAGE
TRANSACTIONS.
COST PER UNIT - What the expected price should be. If unknown,
leave blank.
REQUISITION PRINTED (Y or N) - This is set to Y automatically by
the program whenever a requisition is automatically printed, so
that the next time the automatic requisition report is run, the
requisition will not be printed again.
It is set to N when the item is re-stocked.
If another requisition for the item is required, after one has
automatically been generated, setting REQUISITION PRINTED to N
will force another requisition for the item to be printed the next
time requisitions are printed.
USUAL VENDOR - The vendor name (and optional address) to appear on
any requisition printed automatically.
PHONE/FAX - The vendor's phone or FAX number, printed on automatic
requisitions.
COMMENT - Anything not covered above, such as misc. info.
INV V1.8 DOCUMENTATION, EDITION #1 Page 7
The bottom line shows the available commands:
<Ins>ADD - Adds a new item to inventory file. Items are stored in
object/item order.
<Del>ete - Deletes the displayed item from inventory, permanently.
<E>EDIT - Allows the displayed data of the displayed item to be
changed, added, or deleted. Pressing the down arrow also starts
editing. When done editing, press <Esc>.
<Space> - Requests data to be typed in, then searches inventory,
and displays the next item with any data matching the data that
was typed in. For example, to search for and display the item "5
OHM RESISTER" press <Space> and enter "5 ohm". The "5 OHM
RESISTER" inventory record will be found and displayed.
<Home> - Display the first item in inventory.
<PgDn> - Display the next item, in object/item order.
<PgUp> - Display the previous item, in object/item order.
<up/down arrows> - Move from data field to data field.
EDITING DATA AT A DATA FIELD
Move the cursor to the data field using the up or down arrows,
and start typing. When done press <Enter>. While editing,
<Ins> inserts spaces, <Del> and <Backspace> delete characters,
<Home> and <End> move to the left end and right end of the
data field.
INV V1.8 DOCUMENTATION, EDITION #1 Page 8
Step <2> "ENTER USAGE TRANSACTION."
Whenever an item is "used" from inventory, run the program and
execute step <2> "Enter USAGE transaction."
This step shows the screen "ENTERING INVENTORY USAGE
TRANSACTIONS".
Fill out the data fields:
TRANSACTION DATE - Date of the transaction.
ITEM - Enter any part of the item description or enter MISC for
items not in inventory. The program will scan through inventory
until it finds the full, matching description. Follow the
instructions at the bottom of the screen...
<Space>SCAN - Keep searching for another match.
<Enter>USE - Use the item and object now displayed.
OBJECT - The object, vehicle, machine or project the item is for.
PERSON - The person who removed the item from inventory.
QUANTITY ON FILE - Quantity of the items that should be in
inventory before this transaction.
QUANTITY USED - How many, in the item's units, that were removed
from inventory.
QUANTITY SEEN AFTER TRANSACTION - The quantity that the PERSON saw
left in inventory after this transaction. If this differs from
QUANTITY ON FILE, the program will flash a message and make a
noise, alerting to the discrepancy.
MISC. INFO. - Any miscellaneous details regarding the transaction.
COST PER UNIT - The unit cost of the item, as per the item record
from step 1.
TOTAL COST - Initially set to QUANTITY USED X COST PER UNIT.
Leave as is or enter any different amount.
Adding a transaction is completed by press <Esc> or pressing
<Enter> or <down arrow> until cursor moves below "TOTAL COST".
To print-out an "INVENTORY USAGE TICKET" detailing the re-stocking
transaction, prepare the printer, and press <Shift> & <PrtSc>.
All data entered in this step appears in the transaction report.
To change what was entered, use Step <8> "EDIT USAGE".
INV V1.8 DOCUMENTATION, EDITION #1 Page 9
A form is available that lets you fill out the required
information ahead of time. At the DOS command prompt,
type USAGE and a usage entry form will be printed out.
INV V1.8 DOCUMENTATION, EDITION #1 Page 10
Step <3> "PRINT-OUT PURCHASE REQUISITIONS."
Whenever supplies of an item get low, or there is less than the
set days supply, FAX-ready requisitions will be printed out
automatically (if the AUTOEXEC.BAT file was set. See GENERAL
SETUP STEPS).
To manually print-out requisitions, or to force the automatic
requisition print-out, use this command.
When executed, this command asks (at the bottom of the screen):
<Enter>ANY ITEM
This will print-out requisitions for ANY items in short
supply. The requisitions will appear sorted in vendor order,
with a copy to be FAXED or mailed to a vendor, and an office
tracking copy.
The next PO# will be displayed, and can be changed. Press
<Enter> to use it as is.
Next, the bottom line will provide the following choices:
<P>RINT OUT REPORT
Sends report to the printer.
<Enter>DISPLAYS
Display the report at the screen.
<1>SINGLE ITEM
This command is for generating a requisition manually. When
requested:
Enter any part of the item name being requested;
Enter the quantity to be requisitioned (how many);
The vendor entered into the item's record will be shown.
Press <Enter> to use this vendor, or enter a temporary vendor.
Any change will not affect the vendor stored in the item's
record.
Enter the phone or FAX of this vendor, (if different from what
is displayed).
The next PO# will be displayed, and can be changed. Press
<Enter> to use it as is.
Press <P> to print-out the requisition, or press <Enter> to
display, as per commands at the bottom of the screen.
The program will now search for an item matching the partial
description entered above. The next matching item will be
displayed. Press <Enter> to select it, or press <Space> to
search for the next match.
The requisition will now print-out.
INV V1.8 DOCUMENTATION, EDITION #1 Page 11
THE REQUISITION "INTERNAL USE ONLY" BLANKS
These are to aid in tracking the requisition through re-
stocking, to make sure the computer gets updated.
[ ] ORDERED? DATE ____ ORDERED BY (BUYER) ________
Fill this out when the requisition is sent to the vendor.
[ ] RECEIVED? DATE ____
Fill this out when the items requisitioned have been
received.
[ ] COMPUTER UPDATED (REQ CLOSED)
Mark this ONLY after the items have been restocked, and
program step <4> has been executed to update the computer
with the re-stocking transaction details.
Keep OPEN REQUISITIONS in a handy area to be easily seen, and
assign someone the responsibility of tracking down overdue
requisitions.
INV V1.8 DOCUMENTATION, EDITION #1 Page 12
Step <4> "ENTER RE-STOCKING TRANSACTION DETAILS"
Whenever inventory is re-stocked with an item, run the program and
execute step <4> "Enter RE-STOCKING transactions."
This step shows the screen "ENTERING INVENTORY RE-STOCK
TRANSACTIONS".
Fill out the data fields:
DATE RESTOCKED - Date of the transaction.
ITEM - Enter any part of the item description or enter MISC for
items not in inventory. The program will scan through inventory
until it finds the full, matching description. Follow the
instructions at the bottom of the screen...
<Space>SCAN - Keep searching for another match.
<Enter>USE - Use the item and object now displayed.
OBJECT - The object, vehicle, machine or project the item is for.
QUANTITY RESTOCKED- Quantity of the items that should be in
inventory before this transaction.
QUANTITY SEEN AFTER TRANSACTION - The quantity that the PERSON saw
left in inventory after this transaction. If this differs from
QUANTITY ON FILE, the program will flash a message and make a
noise, alerting to the discrepancy.
QUANTITY ON FILE - Amount in inventory before this transaction.
After the transaction has been added, this changes to QUANTITY NOW
ON FILE and shows the updated amount.
COST PER UNIT - The unit cost of the item.
TOTAL COST - How much the entire amount restocked cost.
PO - Purchase order #.
BUYER - The person responsible for ordering and restocking.
MISC INFO - Anything not covered above.
Adding a transaction is completed by press <Esc> or pressing
<Enter> or <down arrow> until cursor moves below the last data
field.
To print-out an "INVENTORY RESTOCK TICKET" detailing the re-
stocking transaction, prepare the printer, and press <Shift> &
<PrtSc>.
All data entered in this step appears in the transaction report.
INV V1.8 DOCUMENTATION, EDITION #1 Page 13
To change what was entered, use Step <9> "EDIT RE-STOCKING".
A form is available that lets you fill out the required
information ahead of time. At the DOS command prompt,
type RESTOCK and a usage entry form will be printed out.
INV V1.8 DOCUMENTATION, EDITION #1 Page 14
Step <5> "REPORT INVENTORY USAGE TRANSACTIONS & COSTS."
To print-out or display a report of USAGE TRANSACTIONS (what,
when, where, and cost) for a single item, a category of items, or
all items, for any period of time, execute step <5> "REPORT
INVENTORY USAGE".
1. The bottom screen line will present two choices:
<Enter>ANY ITEM
Reports any item for any object.
<C>ATEGORY, ITEM OR OBJECT.
Requests a category of item and a category of object, and
reports only items matching the category. If ITEM CATEGORY is
left blank, any item will be reported. If OBJECT CATEGORY is
left blank, then any object will be reported.
2. Next, the START DATE and the END DATE will be requested to
establish the period of the report. Press just <Enter> for START
DATE to choose earliest, and just <Enter> for END DATE to choose
latest.
3. Next, the bottom screen line requests:
<P>RINT OUT REPORT - Prints out report at printer
<Enter>DISPLAYS - Displays report on-screen.
EXAMPLE
It's 12/01/89. To see how much was spent on OIL FILTERS last
month:
1. Request "<C>ATEGORY, ITEM OR OBJECT" report;
2. Enter OIL FILTER for ITEM CATEGORY, and leave the
object category blank;
3. For the START DATE enter 11/01/89.
For the END DATE enter 11/30/89.
The report will show all usages of oil filters during
November, for all objects (in this case, object means
vehicle), the cost per object, and the cost for all objects
for the entire month.
EXAMPLE
How much should the drafting department be charged for
pencils, that it has used, so far this year?
1. Request "<C>ATEGORY, ITEM OR OBJECT" report;
2. Enter PENCILS for ITEM CATEGORY, and DRAFTING for
object category;
3. For the START DATE enter 01/01/89.
For the END DATE just press <Enter>.
The report will show all pencil usage transactions, with the
total cost at the end of the report.
INV V1.8 DOCUMENTATION, EDITION #1 Page 15
Step <6> "REPORT INVENTORY RE-STOCK TRANASCTIONS & COSTS."
To print-out or display a report of RE-STOCKING transactions
(what, what for, when, and cost), for a single item, a category of
items, or all items, for any period of time, execute step <6>
"REPORT INVENTORY RE-STOCK".
1. The bottom screen line will present two choices:
<Enter>ANY ITEM
Reports any item for any object.
<C>ATEGORY, ITEM OR OBJECT.
Requests a category of item and a category of object, and
reports only items matching the category. If ITEM CATEGORY is
left blank, any item will be reported. If OBJECT CATEGORY is
left blank, then any object will be reported.
2. Next, the START DATE and the END DATE will be requested to
establish the period of the report. Press just <Enter> for START
DATE to choose earliest, and just <Enter> for END DATE to choose
latest.
3. Next, the bottom screen line requests:
<P>RINT OUT REPORT - Prints out report at printer
<Enter>DISPLAYS - Displays report on-screen.
EXAMPLE
It's 12/10/89. How much money went into re-stocking inventory
last month?
1. Request "<Enter>ANY ITEM" report;
2. For the START DATE enter 11/01/89.
For the END DATE enter 11/30/89.
The report will show all re-stock transactions for November,
the cost per each object, and the total cost for all objects
(the total for the month) at the end of the report.
INV V1.8 DOCUMENTATION, EDITION #1 Page 16
Step <7> "REPORT INVENTORY STATUS."
To print-out or display a report of all items in inventory,
execute step <7> "REPORT INVENTORY".
This report is a convenient way to distribute a list of inventory
item, available quantities, costs, locations, and vendors.
The report is in alphabetical object order, with all items for an
object, following that object name, in alphabetical item name
order.
IMPORTANT
If an item is followed by the message "CANNOT AUTO-
REQUISITION!" this means that information necessary for
automatic requisitioning, is missing from that item's record.
The item must have a non-zero PURCHASE QUANTITY, and either a
non-zero QUANTITY LIMIT or non-zero DAYS LIMIT.
INV V1.8 DOCUMENTATION, EDITION #1 Page 17
Step <8> "EDIT USAGE TRANSCTIONS."
Usage transaction information that has been entered with step 2
"ENTER USAGE TRANSACTIONS", can later be searched or changed,
using step <8> "EDIT USAGE TRANSACTION FILE".
When step <8> is executed, the display shows "EDITING INVENTORY
USAGE TRANSACTIONS" and displays the same data fields as step 2
"ENTER USAGE TRANSACTIONS". One transaction is shown at a time.
The bottom line shows the available commands:
<Ins> - Insert a new transaction. Does the same thing as Step 2.
<Del> - Delete the displayed transaction.
<E>DIT - Allow changes to be made to the displayed transaction.
The flashing cursor appears at the top data field. Use the up and
down arrows to select a data field. Press <Esc> when done
editing.
<SPACE>SEARCH - Requests data. Type in the data followed by
<Enter>, and the program will search for and display the next
transaction containing data that matches what was just entered.
<HOME> - Display the earliest transaction.
<PGDN> - Display the next (next latest) transaction.
<PGUP> - Display the previous (next earliest) transaction.
<ESC> - Return to the MAIN MENU.
INV V1.8 DOCUMENTATION, EDITION #1 Page 18
Step <9> "EDIT RE-STOCKING TRANSACTIONS."
Re-stock transaction information that has been entered with step 4
"ENTER RE-STOCKING TRANSACTION", can later be searched or changed,
using step <9> "EDIT RE-STOCK TRANSACTION FILE".
When step <9> is executed, the display shows "EDITING INVENTORY
RE-STOCK TRANSACTIONS" and displays the same data fields as step 4
"ENTER RE-STOCK TRANSACTIONS". One transaction is shown at a
time. The bottom line shows the available commands:
<Ins> - Insert a new transaction. Does the same thing as Step 4.
<Del> - Delete the displayed transaction.
<E>DIT - Allow changes to be made to the displayed transaction.
The flashing cursor appears at the top data field. Use the up and
down arrows to select a data field. Press <Esc> when done
editing.
<SPACE>SEARCH - Requests data. Type in the data followed by
<Enter>, and the program will search for and display the next
transaction containing data that matches what was just entered.
<HOME> - Display the earliest transaction.
<PGDN> - Display the next (next latest) transaction.
<PGUP> - Display the previous (next earliest) transaction.
<ESC> - Return to the MAIN MENU.
INV V1.8 DOCUMENTATION, EDITION #1 Page 19
Step <0> "PURCH OLD TRANSACTIONS (USAGE OR RESTOCK)
Just below this command, the current sizes of the usage and
restock transaction files are shown. The bigger these files get,
the longer it will take to add or edit transactions.
Use this command to remove old transactions, and either move them
to another file, or print them out.
1. Asks if you want to purge USAGE or RESTOCK transactions.
2. Asks for the purge date. Only transactions before this date
will be purged.
3. Asks if the purged transactions should be printed out or
stored in a file. If a file is chosen, the file name will be
requested. For storing on floppy, insert a blank, formatted
floppy disk in drive A: (or substitute B:) and use a filename that
indicates which type of transaction, and the purge date. For
example, if purging all usage transactions before 06/01/89 to
floppy disk in drive A:, then enter the filename: A:\U060189.INV
If purging restock transactions, use: A:\R060189.INV
4. Asks for go-ahead. If printing, prepare the printer with
enough paper to receive all of the purged transactions.
END OF DOCUMENTATION
I N D E X PAGE #
---------------------------------
HARD DISK INSTALLATION 1
GENERAL 1
GENERAL SETUP OPERATIONS 1
GENERAL OPERATION STEPS 3
MISC 4
STEP <1> "ADD/EDIT ITEMS" 5
Step <2> "ENTER USAGE TRANSACTION." 8
Step <3> "PRINT-OUT PURCHASE REQUISITIONS." 10
Step <4> "ENTER RE-STOCKING TRANSACTION DETAILS" 12
Step <5> "REPORT INVENTORY USAGE TRANSACTIONS & COSTS." 14
Step <6> "REPORT INVENTORY RE-STOCK TRANASCTIONS & COSTS." 15
Step <7> "REPORT INVENTORY STATUS." 16
Step <8> "EDIT USAGE TRANSCTIONS." 17
Step <9> "EDIT RE-STOCKING TRANSACTIONS." 18
Step <0> "PURCH OLD TRANSACTIONS (USAGE OR RESTOCK) 19